Dataset info
| Number of variables | 24 |
|---|---|
| Number of observations | 688651 |
| Missing cells | 680435 (4.1%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 126.1 MiB |
| Average record size in memory | 192.0 B |
Variables types
| Numeric | 11 |
|---|---|
| Categorical | 11 |
| Boolean | 2 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
ACCOUNT_CREATED_DATE has 49909 (7.2%) missing values | Missing |
AMOUNT_USD is highly skewed (γ1 = 654.2152316) | Skewed |
AMOUNT_USD has 12126 (1.8%) zeros | Zeros |
BIRTH_YEAR has 49909 (7.2%) missing values | Missing |
COUNTRY has 49909 (7.2%) missing values | Missing |
FAILED_SIGN_IN_ATTEMPTS is highly skewed (γ1 = 20.17361063) | Skewed |
FAILED_SIGN_IN_ATTEMPTS has 635042 (92.2%) zeros | Zeros |
FAILED_SIGN_IN_ATTEMPTS has 49909 (7.2%) missing values | Missing |
HAS_EMAIL has 49909 (7.2%) missing values | Missing |
IS_FRAUDSTER has 49909 (7.2%) missing values | Missing |
KYC has 49909 (7.2%) missing values | Missing |
MERCH_COUNTRIES_USED has 205596 (29.9%) missing values | Missing |
MERCHANT_COUNTRY has a high cardinality: 345 distinct values | Warning |
PHONE_COUNTRY has a high cardinality: 75 distinct values | Warning |
PHONE_COUNTRY has 49909 (7.2%) missing values | Missing |
ROLLING_AVG is highly skewed (γ1 = 75.16437548) | Skewed |
ROLLING_SUM is highly skewed (γ1 = 51.60844599) | Skewed |
TERMS_VERSION has 75567 (11.0%) missing values | Missing |
TIME_SINCE_LAST_TRANSACTION is highly skewed (γ1 = 21.23906615) | Skewed |
TIME_SINCE_LAST_TRANSACTION has 96868 (14.1%) zeros | Zeros |
USER_ID has a high cardinality: 8021 distinct values | Warning |
ACCOUNT_CREATED_DATE
Numeric
| Distinct count | 7749 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 513.2905681 |
|---|---|
| Minimum | 0 |
| Maximum | 940.0294827 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 96.35692163 |
| Q1 | 291.7099367 |
| Median | 553.9698098 |
| Q3 | 722.4251147 |
| 95-th percentile | 857.0172394 |
| Maximum | 940.0294827 |
| Range | 940.0294827 |
| Interquartile range | 430.715178 |
Descriptive statistics
| Standard deviation | 245.9714487 |
|---|---|
| Coef of variation | 0.4792050819 |
| Kurtosis | -1.113199889 |
| Mean | 513.2905681 |
| MAD | 212.660538 |
| Skewness | -0.2851815096 |
| Sum | 327860244.1 |
| Variance | 60501.9536 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 154.7391744 | 2725 | 0.4% | |
| 266.8504718 | 1888 | 0.3% | |
| 697.2446748 | 1856 | 0.3% | |
| 261.3337382 | 1802 | 0.3% | |
| 556.3107027 | 1725 | 0.3% | |
| 73.20995059 | 1559 | 0.2% | |
| 168.8945824 | 1513 | 0.2% | |
| 618.0554057 | 1496 | 0.2% | |
| 598.9775755 | 1448 | 0.2% | |
| 606.5665685 | 1441 | 0.2% | |
| Other values (7738) | 621289 | 90.2% | |
| (Missing) | 49909 | 7.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 148 | < 0.1% | |
| 0.09821409722 | 165 | < 0.1% | |
| 0.2424634259 | 7 | < 0.1% | |
| 0.854335081 | 357 | 0.1% | |
| 0.8919533796 | 51 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 940.0294827 | 2 | < 0.1% | |
| 940.0103932 | 2 | < 0.1% | |
| 940.0069005 | 5 | < 0.1% | |
| 939.8503398 | 2 | < 0.1% | |
| 939.8478982 | 2 | < 0.1% |
AMOUNT_USD
Numeric
| Distinct count | 32381 |
|---|---|
| Unique (%) | 4.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7130792.755 |
|---|---|
| Minimum | 0 |
| Maximum | 1.657094872e+12 |
| Zeros (%) | 1.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 66 |
| Q1 | 515 |
| Median | 1475 |
| Q3 | 5406 |
| 95-th percentile | 33389 |
| Maximum | 1.657094872e+12 |
| Range | 1.657094872e+12 |
| Interquartile range | 4891 |
Descriptive statistics
| Standard deviation | 2248502125 |
|---|---|
| Coef of variation | 315.3228823 |
| Kurtosis | 455145.2689 |
| Mean | 7130792.755 |
| MAD | 14229081.08 |
| Skewness | 654.2152316 |
| Sum | 4.910627561e+12 |
| Variance | 5.055761804e+18 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 1260 | 14434 | 2.1% | |
| 126 | 13815 | 2.0% | |
| 0 | 12126 | 1.8% | |
| 12606 | 10997 | 1.6% | |
| 111 | 10423 | 1.5% | |
| 6303 | 9065 | 1.3% | |
| 1112 | 8939 | 1.3% | |
| 2521 | 8182 | 1.2% | |
| 11129 | 7346 | 1.1% | |
| 2225 | 7005 | 1.0% | |
| Other values (32371) | 586319 | 85.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 12126 | 1.8% | |
| 1 | 1440 | 0.2% | |
| 2 | 506 | 0.1% | |
| 3 | 307 | < 0.1% | |
| 4 | 237 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.657094872e+12 | 1 | < 0.1% | |
| 8.285474362e+11 | 1 | < 0.1% | |
| 1.082269209e+11 | 1 | < 0.1% | |
| 6.649063054e+10 | 1 | < 0.1% | |
| 6.167100452e+10 | 1 | < 0.1% |
BIRTH_YEAR
Numeric
| Distinct count | 68 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1984.940629 |
|---|---|
| Minimum | 1927 |
| Maximum | 2000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1927 |
|---|---|
| 5-th percentile | 1965 |
| Q1 | 1980 |
| Median | 1987 |
| Q3 | 1992 |
| 95-th percentile | 1997 |
| Maximum | 2000 |
| Range | 73 |
| Interquartile range | 12 |
Descriptive statistics
| Standard deviation | 9.887921541 |
|---|---|
| Coef of variation | 0.004981469671 |
| Kurtosis | 1.929580814 |
| Mean | 1984.940629 |
| MAD | 7.529709605 |
| Skewness | -1.319251445 |
| Sum | 1267864947 |
| Variance | 97.7709924 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 1991 | 40150 | 5.8% | |
| 1990 | 37738 | 5.5% | |
| 1993 | 34553 | 5.0% | |
| 1989 | 34429 | 5.0% | |
| 1994 | 32689 | 4.7% | |
| 1988 | 31719 | 4.6% | |
| 1987 | 30006 | 4.4% | |
| 1992 | 29374 | 4.3% | |
| 1984 | 28115 | 4.1% | |
| 1986 | 26033 | 3.8% | |
| Other values (57) | 313936 | 45.6% | |
| (Missing) | 49909 | 7.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1927 | 2 | < 0.1% | |
| 1928 | 41 | < 0.1% | |
| 1930 | 25 | < 0.1% | |
| 1931 | 4 | < 0.1% | |
| 1936 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2000 | 1255 | 0.2% | |
| 1999 | 4160 | 0.6% | |
| 1998 | 12837 | 1.9% | |
| 1997 | 17311 | 2.5% | |
| 1996 | 17788 | 2.6% |
COUNT
Numeric
| Distinct count | 2725 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 210.452762 |
|---|---|
| Minimum | 1 |
| Maximum | 2725 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 36 |
| Median | 107 |
| Q3 | 271 |
| 95-th percentile | 769 |
| Maximum | 2725 |
| Range | 2724 |
| Interquartile range | 235 |
Descriptive statistics
| Standard deviation | 283.1574549 |
|---|---|
| Coef of variation | 1.345467991 |
| Kurtosis | 12.27753521 |
| Mean | 210.452762 |
| MAD | 190.1994128 |
| Skewness | 2.933569474 |
| Sum | 144928505 |
| Variance | 80178.14426 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 1 | 8021 | 1.2% | |
| 2 | 7704 | 1.1% | |
| 3 | 6994 | 1.0% | |
| 4 | 6582 | 1.0% | |
| 5 | 6271 | 0.9% | |
| 6 | 6036 | 0.9% | |
| 7 | 5838 | 0.8% | |
| 8 | 5669 | 0.8% | |
| 9 | 5531 | 0.8% | |
| 10 | 5393 | 0.8% | |
| Other values (2715) | 624612 | 90.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 8021 | 1.2% | |
| 2 | 7704 | 1.1% | |
| 3 | 6994 | 1.0% | |
| 4 | 6582 | 1.0% | |
| 5 | 6271 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2725 | 1 | < 0.1% | |
| 2724 | 1 | < 0.1% | |
| 2723 | 1 | < 0.1% | |
| 2722 | 1 | < 0.1% | |
| 2721 | 1 | < 0.1% |
COUNTRY
Categorical
| Distinct count | 45 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| GB | |
|---|---|
| FR | 60041 |
| LT | 48154 |
| Other values (41) | |
| (Missing) | 49909 |
| Value | Count | Frequency (%) | |
| GB | 348946 | 50.7% | |
| FR | 60041 | 8.7% | |
| LT | 48154 | 7.0% | |
| IE | 41723 | 6.1% | |
| PL | 25005 | 3.6% | |
| ES | 19311 | 2.8% | |
| DE | 8988 | 1.3% | |
| PT | 8137 | 1.2% | |
| LV | 7570 | 1.1% | |
| RO | 6903 | 1.0% | |
| Other values (34) | 63964 | 9.3% | |
| (Missing) | 49909 | 7.2% |
| Max length | 4 |
|---|---|
| Mean length | 2.14494715 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
CURRENCIES_USED
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.26227799 |
|---|---|
| Minimum | 1 |
| Maximum | 8 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.6042684084 |
|---|---|
| Coef of variation | 0.4787126237 |
| Kurtosis | 12.23482698 |
| Mean | 1.26227799 |
| MAD | 0.4204873932 |
| Skewness | 2.976908195 |
| Sum | 869269 |
| Variance | 0.3651403093 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 1 | 552027 | 80.2% | |
| 2 | 103538 | 15.0% | |
| 3 | 25004 | 3.6% | |
| 4 | 6194 | 0.9% | |
| 5 | 1287 | 0.2% | |
| 6 | 365 | 0.1% | |
| 7 | 135 | < 0.1% | |
| 8 | 101 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 552027 | 80.2% | |
| 2 | 103538 | 15.0% | |
| 3 | 25004 | 3.6% | |
| 4 | 6194 | 0.9% | |
| 5 | 1287 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 101 | < 0.1% | |
| 7 | 135 | < 0.1% | |
| 6 | 365 | 0.1% | |
| 5 | 1287 | 0.2% | |
| 4 | 6194 | 0.9% |
CURRENCY
Categorical
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| GBP | |
|---|---|
| EUR | |
| USD | 31542 |
| Other values (26) | 53323 |
| Value | Count | Frequency (%) | |
| GBP | 339091 | 49.2% | |
| EUR | 264695 | 38.4% | |
| USD | 31542 | 4.6% | |
| PLN | 22362 | 3.2% | |
| RON | 5837 | 0.8% | |
| CHF | 5761 | 0.8% | |
| NOK | 2602 | 0.4% | |
| AUD | 2110 | 0.3% | |
| DKK | 1711 | 0.2% | |
| SEK | 1579 | 0.2% | |
| Other values (19) | 11361 | 1.6% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
ENTRY_METHOD
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| misc | |
|---|---|
| chip | |
| cont | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| misc | 227362 | 33.0% | |
| chip | 183662 | 26.7% | |
| cont | 160872 | 23.4% | |
| manu | 93952 | 13.6% | |
| mags | 22311 | 3.2% | |
| mcon | 492 | 0.1% |
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
FAILED_SIGN_IN_ATTEMPTS
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.009551587339 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros (%) | 92.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1411770766 |
|---|---|
| Coef of variation | 14.78048324 |
| Kurtosis | 560.8706272 |
| Mean | 0.009551587339 |
| MAD | 0.01899251694 |
| Skewness | 20.17361063 |
| Sum | 6101 |
| Variance | 0.01993096696 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 635042 | 92.2% | |
| 1 | 1762 | 0.3% | |
| 2 | 1715 | 0.2% | |
| 3 | 143 | < 0.1% | |
| 6 | 80 | < 0.1% | |
| (Missing) | 49909 | 7.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 635042 | 92.2% | |
| 1 | 1762 | 0.3% | |
| 2 | 1715 | 0.2% | |
| 3 | 143 | < 0.1% | |
| 6 | 80 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6 | 80 | < 0.1% | |
| 3 | 143 | < 0.1% | |
| 2 | 1715 | 0.2% | |
| 1 | 1762 | 0.3% | |
| 0 | 635042 | 92.2% |
HAS_EMAIL
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| 1 | |
|---|---|
| 0 | 6863 |
| (Missing) | 49909 |
| Value | Count | Frequency (%) | |
| 1 | 631879 | 91.8% | |
| 0 | 6863 | 1.0% | |
| (Missing) | 49909 | 7.2% |
IS_FRAUDSTER
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| False | |
|---|---|
| True | 13914 |
| (Missing) | 49909 |
| Value | Count | Frequency (%) | |
| False | 624828 | 90.7% | |
| True | 13914 | 2.0% | |
| (Missing) | 49909 | 7.2% |
KYC
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| PASSED | |
|---|---|
| NONE | 4879 |
| PENDING | 2283 |
| (Missing) | 49909 |
| Value | Count | Frequency (%) | |
| PASSED | 629811 | 91.5% | |
| NONE | 4879 | 0.7% | |
| PENDING | 2283 | 0.3% | |
| FAILED | 1769 | 0.3% | |
| (Missing) | 49909 | 7.2% |
| Max length | 7 |
|---|---|
| Mean length | 5.844198295 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
MERCH_COUNTRIES_USED
Numeric
| Distinct count | 48 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 29.9% |
| Missing (n) | 205596 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.266474832 |
|---|---|
| Minimum | 1 |
| Maximum | 47 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 47 |
| Range | 46 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 3.528709355 |
|---|---|
| Coef of variation | 1.080280589 |
| Kurtosis | 12.63899963 |
| Mean | 3.266474832 |
| MAD | 2.385861324 |
| Skewness | 2.915221279 |
| Sum | 1577887 |
| Variance | 12.45178971 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 1 | 195596 | 28.4% | |
| 2 | 93177 | 13.5% | |
| 3 | 56033 | 8.1% | |
| 4 | 32505 | 4.7% | |
| 5 | 27073 | 3.9% | |
| 6 | 19061 | 2.8% | |
| 7 | 12516 | 1.8% | |
| 8 | 9644 | 1.4% | |
| 9 | 8416 | 1.2% | |
| 10 | 5472 | 0.8% | |
| Other values (37) | 23562 | 3.4% | |
| (Missing) | 205596 | 29.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 195596 | 28.4% | |
| 2 | 93177 | 13.5% | |
| 3 | 56033 | 8.1% | |
| 4 | 32505 | 4.7% | |
| 5 | 27073 | 3.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 47 | 1 | < 0.1% | |
| 46 | 8 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 44 | 6 | < 0.1% | |
| 43 | 12 | < 0.1% |
MERCHANT_COUNTRY
Categorical
| Distinct count | 345 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| GBR | |
| USA | 46050 |
| Other values (342) |
| Value | Count | Frequency (%) | |
| 0 | 205596 | 29.9% | |
| GBR | 146200 | 21.2% | |
| USA | 46050 | 6.7% | |
| FRA | 28980 | 4.2% | |
| IRL | 26196 | 3.8% | |
| LTU | 25597 | 3.7% | |
| ESP | 23329 | 3.4% | |
| NLD | 18532 | 2.7% | |
| AUS | 10088 | 1.5% | |
| POL | 10028 | 1.5% | |
| Other values (335) | 148055 | 21.5% |
| Max length | 3 |
|---|---|
| Mean length | 2.402250196 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
PHONE_COUNTRY
Categorical
| Distinct count | 75 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 7.2% |
| Missing (n) | 49909 |
| GB||JE||IM||GG | |
|---|---|
| FR | 63293 |
| LT | 48740 |
| Other values (71) | |
| (Missing) | 49909 |
| Value | Count | Frequency (%) | |
| GB||JE||IM||GG | 328346 | 47.7% | |
| FR | 63293 | 9.2% | |
| LT | 48740 | 7.1% | |
| IE | 41184 | 6.0% | |
| PL | 26674 | 3.9% | |
| ES | 17325 | 2.5% | |
| DE | 11402 | 1.7% | |
| PT | 8112 | 1.2% | |
| RO | 8016 | 1.2% | |
| LV | 7865 | 1.1% | |
| Other values (64) | 77785 | 11.3% | |
| (Missing) | 49909 | 7.2% |
| Max length | 14 |
|---|---|
| Mean length | 7.983416854 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
ROLLING_AVG
Numeric
| Distinct count | 539512 |
|---|---|
| Unique (%) | 78.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5180059.39 |
|---|---|
| Minimum | 0 |
| Maximum | 2.716549277e+10 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 3091.45 |
| Median | 5661.06 |
| Q3 | 10313.355 |
| 95-th percentile | 44495.085 |
| Maximum | 2.716549277e+10 |
| Range | 2.716549277e+10 |
| Interquartile range | 7221.905 |
Descriptive statistics
| Standard deviation | 221151348.9 |
|---|---|
| Coef of variation | 42.69282111 |
| Kurtosis | 6617.474948 |
| Mean | 5180059.39 |
| MAD | 10129257.09 |
| Skewness | 75.16437548 |
| Sum | 3.567253079e+12 |
| Variance | 4.890791912e+16 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 126 | 4401 | 0.6% | |
| 111 | 3600 | 0.5% | |
| 693 | 1781 | 0.3% | |
| 611.5 | 1127 | 0.2% | |
| 25 | 620 | 0.1% | |
| 882 | 470 | 0.1% | |
| 1260 | 356 | 0.1% | |
| 504 | 352 | 0.1% | |
| 3214.5 | 307 | < 0.1% | |
| 2837.5 | 274 | < 0.1% | |
| Other values (539502) | 675363 | 98.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 169 | < 0.1% | |
| 0.33 | 1 | < 0.1% | |
| 0.5 | 1 | < 0.1% | |
| 0.67 | 1 | < 0.1% | |
| 1 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.716549277e+10 | 1 | < 0.1% | |
| 2.672733972e+10 | 1 | < 0.1% | |
| 2.630309676e+10 | 1 | < 0.1% | |
| 2.589211136e+10 | 1 | < 0.1% | |
| 2.549377125e+10 | 1 | < 0.1% |
ROLLING_SUM
Numeric
| Distinct count | 565098 |
|---|---|
| Unique (%) | 82.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 848903689.5 |
|---|---|
| Minimum | 0 |
| Maximum | 1.657096214e+12 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12518 |
| Q1 | 196310.5 |
| Median | 662280 |
| Q3 | 1840874 |
| 95-th percentile | 8690098 |
| Maximum | 1.657096214e+12 |
| Range | 1.657096214e+12 |
| Interquartile range | 1644563.5 |
Descriptive statistics
| Standard deviation | 2.566105873e+10 |
|---|---|
| Coef of variation | 30.22846884 |
| Kurtosis | 3026.587552 |
| Mean | 848903689.5 |
| MAD | 1654299448 |
| Skewness | 51.60844599 |
| Sum | 5.845983747e+14 |
| Variance | 6.584899349e+20 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 126 | 3302 | 0.5% | |
| 111 | 2430 | 0.4% | |
| 1386 | 1670 | 0.2% | |
| 1223 | 1051 | 0.2% | |
| 252 | 572 | 0.1% | |
| 222 | 524 | 0.1% | |
| 25 | 483 | 0.1% | |
| 2646 | 461 | 0.1% | |
| 1512 | 356 | 0.1% | |
| 1260 | 316 | < 0.1% | |
| Other values (565088) | 677486 | 98.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 169 | < 0.1% | |
| 1 | 9 | < 0.1% | |
| 2 | 4 | < 0.1% | |
| 4 | 39 | < 0.1% | |
| 5 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.657096214e+12 | 1 | < 0.1% | |
| 1.657096211e+12 | 1 | < 0.1% | |
| 1.657096206e+12 | 1 | < 0.1% | |
| 1.657096205e+12 | 1 | < 0.1% | |
| 1.657096205e+12 | 1 | < 0.1% |
SOURCE
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| GAIA | |
|---|---|
| HERA | |
| INTERNAL | 56407 |
| Other values (8) | 32332 |
| Value | Count | Frequency (%) | |
| GAIA | 483831 | 70.3% | |
| HERA | 116081 | 16.9% | |
| INTERNAL | 56407 | 8.2% | |
| MINOS | 11056 | 1.6% | |
| LETO | 6935 | 1.0% | |
| CRONUS | 6139 | 0.9% | |
| NYX | 5178 | 0.8% | |
| OPHION | 1278 | 0.2% | |
| LIMOS | 961 | 0.1% | |
| APOLLO | 784 | 0.1% |
| Max length | 8 |
|---|---|
| Mean length | 4.361387699 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
TERMS_VERSION
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 11.0% |
| Missing (n) | 75567 |
| 2018-09-20 | |
|---|---|
| 2018-05-25 | |
| 2018-03-20 | |
| Other values (4) | 22879 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 2018-09-20 | 298644 | 43.4% | |
| 2018-05-25 | 213103 | 30.9% | |
| 2018-03-20 | 78458 | 11.4% | |
| 2018-01-01 | 7345 | 1.1% | |
| 2017-01-16 | 6844 | 1.0% | |
| 2018-01-13 | 5585 | 0.8% | |
| 2017-02-02 | 3105 | 0.5% | |
| (Missing) | 75567 | 11.0% |
| Max length | 10 |
|---|---|
| Mean length | 9.341608449 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
TIME_SINCE_LAST_TRANSACTION
Numeric
| Distinct count | 34188 |
|---|---|
| Unique (%) | 5.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3202.712086 |
|---|---|
| Minimum | 0 |
| Maximum | 1514745 |
| Zeros (%) | 14.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| Median | 199 |
| Q3 | 1272 |
| 95-th percentile | 10377 |
| Maximum | 1514745 |
| Range | 1514745 |
| Interquartile range | 1262 |
Descriptive statistics
| Standard deviation | 19712.5374 |
|---|---|
| Coef of variation | 6.15495145 |
| Kurtosis | 690.4626931 |
| Mean | 3202.712086 |
| MAD | 4763.704205 |
| Skewness | 21.23906615 |
| Sum | 2205550881 |
| Variance | 388584130.8 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 0 | 96868 | 14.1% | |
| 1 | 21593 | 3.1% | |
| 2 | 12015 | 1.7% | |
| 3 | 8475 | 1.2% | |
| 4 | 6797 | 1.0% | |
| 5 | 5660 | 0.8% | |
| 6 | 4855 | 0.7% | |
| 7 | 4414 | 0.6% | |
| 8 | 4020 | 0.6% | |
| 9 | 3932 | 0.6% | |
| Other values (34178) | 520022 | 75.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 96868 | 14.1% | |
| 1 | 21593 | 3.1% | |
| 2 | 12015 | 1.7% | |
| 3 | 8475 | 1.2% | |
| 4 | 6797 | 1.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1514745 | 1 | < 0.1% | |
| 1283293 | 1 | < 0.1% | |
| 1151261 | 1 | < 0.1% | |
| 1139724 | 1 | < 0.1% | |
| 1061079 | 1 | < 0.1% |
TRANSACTION_DATE
Numeric
| Distinct count | 688640 |
|---|---|
| Unique (%) | > 99.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1016.787528 |
|---|---|
| Minimum | 0 |
| Maximum | 1246.064319 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 536.7981409 |
| Q1 | 908.4072873 |
| Median | 1095.676915 |
| Q3 | 1186.924301 |
| 95-th percentile | 1235.155439 |
| Maximum | 1246.064319 |
| Range | 1246.064319 |
| Interquartile range | 278.5170136 |
Descriptive statistics
| Standard deviation | 221.8661987 |
|---|---|
| Coef of variation | 0.2182031079 |
| Kurtosis | 1.150564108 |
| Mean | 1016.787528 |
| MAD | 175.7797174 |
| Skewness | -1.306616991 |
| Sum | 700211747.9 |
| Variance | 49224.61012 |
| Memory size | 5.3 MiB |
| Value | Count | Frequency (%) | |
| 1179.053614 | 2 | < 0.1% | |
| 1227.960335 | 2 | < 0.1% | |
| 1187.160424 | 2 | < 0.1% | |
| 1222.209915 | 2 | < 0.1% | |
| 1146.055195 | 2 | < 0.1% | |
| 1158.768694 | 2 | < 0.1% | |
| 1168.202019 | 2 | < 0.1% | |
| 1172.837944 | 2 | < 0.1% | |
| 1222.910702 | 2 | < 0.1% | |
| 406.8574973 | 2 | < 0.1% | |
| Other values (688630) | 688631 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1.984719109 | 1 | < 0.1% | |
| 56.34827697 | 1 | < 0.1% | |
| 56.35596095 | 1 | < 0.1% | |
| 56.37551001 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1246.064319 | 1 | < 0.1% | |
| 1246.064063 | 1 | < 0.1% | |
| 1246.06386 | 1 | < 0.1% | |
| 1246.063738 | 1 | < 0.1% | |
| 1246.063441 | 1 | < 0.1% |
TRANSACTION_STATE
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| COMPLETED | |
|---|---|
| DECLINED | 45635 |
| REVERTED | 38663 |
| Other values (4) | 19846 |
| Value | Count | Frequency (%) | |
| COMPLETED | 584507 | 84.9% | |
| DECLINED | 45635 | 6.6% | |
| REVERTED | 38663 | 5.6% | |
| FAILED | 16763 | 2.4% | |
| PENDING | 2477 | 0.4% | |
| CANCELLED | 515 | 0.1% | |
| RECORDED | 91 | < 0.1% |
| Max length | 9 |
|---|---|
| Mean length | 8.797238369 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
TYPE
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| CARD_PAYMENT | |
|---|---|
| TOPUP | |
| P2P | 56338 |
| Other values (2) | 63182 |
| Value | Count | Frequency (%) | |
| CARD_PAYMENT | 436570 | 63.4% | |
| TOPUP | 132561 | 19.2% | |
| P2P | 56338 | 8.2% | |
| ATM | 47324 | 6.9% | |
| BANK_TRANSFER | 15858 | 2.3% |
| Max length | 13 |
|---|---|
| Mean length | 9.320809815 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
USER_ID
Categorical
| Distinct count | 8021 |
|---|---|
| Unique (%) | 1.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 84e22e7f-f2ab-413c-969a-667c78d8885c | 2725 |
|---|---|
| 26e8432c-5fdb-4b67-82e6-18f341d511a1 | 2571 |
| f54baeeb-7282-4d23-9bb7-e8396ce1b159 | 2293 |
| Other values (8018) |
| Value | Count | Frequency (%) | |
| 84e22e7f-f2ab-413c-969a-667c78d8885c | 2725 | 0.4% | |
| 26e8432c-5fdb-4b67-82e6-18f341d511a1 | 2571 | 0.4% | |
| f54baeeb-7282-4d23-9bb7-e8396ce1b159 | 2293 | 0.3% | |
| 8dd8b009-bcc7-4b14-a26f-c87c232383f4 | 1888 | 0.3% | |
| 4366241f-0cac-4978-a4a3-27f38abc174a | 1856 | 0.3% | |
| d1bc3cd6-154e-479f-8957-a69cdf414462 | 1844 | 0.3% | |
| 0314aa87-cf7e-43f2-86c6-ae36dfa4d9b0 | 1802 | 0.3% | |
| dc78fbc4-c936-45d3-a813-e2477ac6d74b | 1725 | 0.3% | |
| 0fe472c9-cf3e-4e43-90f3-a0cfb6a4f1f0 | 1686 | 0.2% | |
| 6cae3eb6-515c-4811-8b51-32fb2e95da28 | 1559 | 0.2% | |
| Other values (8011) | 668702 | 97.1% |
| Max length | 36 |
|---|---|
| Mean length | 36 |
| Min length | 36 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
First rows
| ACCOUNT_CREATED_DATE | AMOUNT_USD | BIRTH_YEAR | COUNT | COUNTRY | CURRENCIES_USED | CURRENCY | ENTRY_METHOD | FAILED_SIGN_IN_ATTEMPTS | HAS_EMAIL | IS_FRAUDSTER | KYC | MERCH_COUNTRIES_USED | MERCHANT_COUNTRY | PHONE_COUNTRY | ROLLING_AVG | ROLLING_SUM | SOURCE | TERMS_VERSION | TIME_SINCE_LAST_TRANSACTION | TRANSACTION_DATE | TRANSACTION_STATE | TYPE | USER_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 789.008585 | 14 | 1989.0 | 1 | DK | 1 | DKK | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | DK | 14.00 | 14.0 | HERA | 2018-03-20 | 0.0 | 1100.318753 | REVERTED | TOPUP | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 1 | 789.008585 | 1490 | 1989.0 | 2 | DK | 1 | DKK | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | DK | 752.00 | 1504.0 | HERA | 2018-03-20 | 0.0 | 1100.318955 | COMPLETED | TOPUP | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 2 | 789.008585 | 7451 | 1989.0 | 3 | DK | 1 | DKK | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | DK | 2985.00 | 8955.0 | HERA | 2018-03-20 | 62886.0 | 1143.990318 | COMPLETED | TOPUP | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 3 | 789.008585 | 8880 | 1989.0 | 4 | DK | 1 | DKK | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | DK | 4458.75 | 17835.0 | CRONUS | 2018-03-20 | 5.0 | 1143.994202 | COMPLETED | BANK_TRANSFER | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 4 | 789.008585 | 7451 | 1989.0 | 5 | DK | 1 | DKK | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | DK | 5057.20 | 25286.0 | HERA | 2018-03-20 | 17633.0 | 1156.239779 | COMPLETED | TOPUP | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 5 | 789.008585 | 5216 | 1989.0 | 6 | DK | 1 | DKK | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | DK | 5083.67 | 30502.0 | INTERNAL | 2018-03-20 | 1.0 | 1156.240639 | COMPLETED | P2P | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 6 | 789.008585 | 559 | 1989.0 | 7 | DK | 1 | DKK | cont | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | DK | 4437.29 | 31061.0 | GAIA | 2018-03-20 | 55777.0 | 1194.975126 | REVERTED | CARD_PAYMENT | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 7 | 789.008585 | 559 | 1989.0 | 8 | DK | 1 | DKK | cont | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | DK | 3952.50 | 31620.0 | GAIA | 2018-03-20 | 2.0 | 1194.977094 | REVERTED | CARD_PAYMENT | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 8 | 789.008585 | 89 | 1989.0 | 9 | DK | 1 | DKK | cont | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | DK | 3523.22 | 31709.0 | GAIA | 2018-03-20 | 247.0 | 1195.148885 | COMPLETED | CARD_PAYMENT | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
| 9 | 789.008585 | 67 | 1989.0 | 10 | DK | 1 | DKK | cont | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | DK | 3177.60 | 31776.0 | GAIA | 2018-03-20 | 4.0 | 1195.151880 | COMPLETED | CARD_PAYMENT | 000e88bb-d302-4fdc-b757-2b1a2c33e7d6 |
Last rows
| ACCOUNT_CREATED_DATE | AMOUNT_USD | BIRTH_YEAR | COUNT | COUNTRY | CURRENCIES_USED | CURRENCY | ENTRY_METHOD | FAILED_SIGN_IN_ATTEMPTS | HAS_EMAIL | IS_FRAUDSTER | KYC | MERCH_COUNTRIES_USED | MERCHANT_COUNTRY | PHONE_COUNTRY | ROLLING_AVG | ROLLING_SUM | SOURCE | TERMS_VERSION | TIME_SINCE_LAST_TRANSACTION | TRANSACTION_DATE | TRANSACTION_STATE | TYPE | USER_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 688641 | 439.026435 | 6 | 1986.0 | 50 | FR | 1 | EUR | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | FR | 3182.76 | 159138.0 | LETO | 2018-09-20 | 0.0 | 1162.760362 | COMPLETED | TOPUP | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688642 | 439.026435 | 44613 | 1986.0 | 51 | FR | 1 | EUR | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | FR | 3995.12 | 203751.0 | LETO | 2018-09-20 | 22111.0 | 1178.115361 | COMPLETED | TOPUP | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688643 | 439.026435 | 4256 | 1986.0 | 52 | FR | 1 | EUR | chip | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | FR | 4000.13 | 208007.0 | GAIA | 2018-09-20 | 3259.0 | 1180.378689 | COMPLETED | CARD_PAYMENT | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688644 | 439.026435 | 3305 | 1986.0 | 53 | FR | 1 | EUR | chip | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | FR | 3987.02 | 211312.0 | GAIA | 2018-09-20 | 3492.0 | 1182.803769 | COMPLETED | CARD_PAYMENT | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688645 | 439.026435 | 1112 | 1986.0 | 54 | FR | 1 | EUR | manu | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | FR | 3933.78 | 212424.0 | GAIA | 2018-09-20 | 8833.0 | 1188.937927 | COMPLETED | CARD_PAYMENT | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688646 | 439.026435 | 8665 | 1986.0 | 55 | FR | 1 | EUR | manu | 0.0 | 1.0 | False | PASSED | 4.0 | GBR | FR | 4019.80 | 221089.0 | GAIA | 2018-09-20 | 48856.0 | 1222.865922 | COMPLETED | CARD_PAYMENT | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688647 | 439.026435 | 8665 | 1986.0 | 56 | FR | 1 | EUR | manu | 0.0 | 1.0 | False | PASSED | 4.0 | GBR | FR | 4102.75 | 229754.0 | GAIA | 2018-09-20 | 0.0 | 1222.866171 | DECLINED | CARD_PAYMENT | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688648 | 439.026435 | 2003 | 1986.0 | 57 | FR | 1 | EUR | manu | 0.0 | 1.0 | False | PASSED | 1.0 | FRA | FR | 4065.91 | 231757.0 | GAIA | 2018-09-20 | 25834.0 | 1240.807053 | COMPLETED | CARD_PAYMENT | ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33 |
| 688649 | 929.089708 | 23 | 1963.0 | 1 | RO | 1 | RON | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | RO | 23.00 | 23.0 | HERA | 2018-05-25 | 0.0 | 1236.891665 | REVERTED | TOPUP | fff200b0-5204-4f7d-86eb-3bb5654b4636 |
| 688650 | 929.089708 | 2341 | 1963.0 | 2 | RO | 1 | RON | misc | 0.0 | 1.0 | False | PASSED | NaN | 0 | RO | 1182.00 | 2364.0 | HERA | 2018-05-25 | 0.0 | 1236.891972 | COMPLETED | TOPUP | fff200b0-5204-4f7d-86eb-3bb5654b4636 |